CREATE TABLE [dbo].[Name_Address]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_ID] DEFAULT (''),
[ADDRESS_NUM] [int] NOT NULL CONSTRAINT [DF_Name_Address_ADDRESS_NUM] DEFAULT ((0)),
[PURPOSE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_PURPOSE] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_COMPANY] DEFAULT (''),
[ADDRESS_1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_ADDRESS_2] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_ZIP] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_COUNTRY] DEFAULT (''),
[CRRT] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_CRRT] DEFAULT (''),
[DPB] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_DPB] DEFAULT (''),
[BAR_CODE] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_BAR_CODE] DEFAULT (''),
[COUNTRY_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_COUNTRY_CODE] DEFAULT (''),
[ADDRESS_FORMAT] [tinyint] NOT NULL CONSTRAINT [DF_Name_Address_ADDRESS_FORMAT] DEFAULT ((0)),
[FULL_ADDRESS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_FULL_ADDRESS] DEFAULT (''),
[COUNTY] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_COUNTY] DEFAULT (''),
[US_CONGRESS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_US_CONGRESS] DEFAULT (''),
[STATE_SENATE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_STATE_SENATE] DEFAULT (''),
[STATE_HOUSE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_STATE_HOUSE] DEFAULT (''),
[MAIL_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_MAIL_CODE] DEFAULT (''),
[PHONE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_PHONE] DEFAULT (''),
[FAX] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_FAX] DEFAULT (''),
[TOLL_FREE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_TOLL_FREE] DEFAULT (''),
[COMPANY_SORT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_COMPANY_SORT] DEFAULT (''),
[NOTE] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STATUS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_STATUS] DEFAULT (''),
[LAST_UPDATED] [datetime] NULL,
[LIST_STRING] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_LIST_STRING] DEFAULT (''),
[PREFERRED_MAIL] [bit] NOT NULL CONSTRAINT [DF_Name_Address_PREFERRED_MAIL] DEFAULT ((0)),
[PREFERRED_BILL] [bit] NOT NULL CONSTRAINT [DF_Name_Address_PREFERRED_BILL] DEFAULT ((0)),
[LAST_VERIFIED] [datetime] NULL,
[EMAIL] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_EMAIL] DEFAULT (''),
[BAD_ADDRESS] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_BAD_ADDRESS] DEFAULT (''),
[NO_AUTOVERIFY] [bit] NOT NULL CONSTRAINT [DF_Name_Address_NO_AUTOVERIFY] DEFAULT ((0)),
[LAST_QAS_BATCH] [datetime] NULL,
[ADDRESS_3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Address_ADDRESS_3] DEFAULT (''),
[PREFERRED_SHIP] [bit] NOT NULL CONSTRAINT [DF_Name_Address_PREFERRED_SHIP] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[Name_Address] ADD CONSTRAINT [PK_Name_Address] PRIMARY KEY NONCLUSTERED ([ADDRESS_NUM]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iName_AddressID] ON [dbo].[Name_Address] ([ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iName_AddressLAST_QAS_BATCH] ON [dbo].[Name_Address] ([LAST_QAS_BATCH]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iName_AddressLAST_VERIFIED] ON [dbo].[Name_Address] ([LAST_VERIFIED]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Name_Address] TO [IMIS]
GRANT SELECT ON  [dbo].[Name_Address] TO [IMIS]
GRANT INSERT ON  [dbo].[Name_Address] TO [IMIS]
GRANT DELETE ON  [dbo].[Name_Address] TO [IMIS]
GRANT UPDATE ON  [dbo].[Name_Address] TO [IMIS]
GO